package com.abel.roommanager.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import com.abel.roommanager.pojo.Landlord;

public interface LandlordMapper {
	@Select("select * from landlord where id=#{lid}")
	public Landlord findLandlordByLid(int lid);
    @Select("select * from landlord where lname=#{lname} and tel=#{tel}")
	public Landlord findLandlordByLnameAndTel(Landlord landlord);
    @Insert("insert into landlord(lname,tel) values(#{lname},#{tel})")
	public void addLandlord(Landlord landlord);
    @Select("SELECT LAST_INSERT_ID()")
	public int findLastInsertId();
}
